Tabela LMedResourceOrgUnit

Definicja tabeli LMedResourceOrgUnit

Name

LMedResourceOrgUnit

Code

LMedResourceOrgUnit

Comment

PL: Przyporzadkowanie lekarza/urzadzenia do placówki
EN: Assignement medical resource to an organization unit


Lista kolumn tabeli LMedResourceOrgUnit

Name

Code

MedResourceID

MedResourceID

LPersonnelTypeID

LPersonnelTypeID

Active

Active

StartDT

StartDT

StopDT

StopDT


Kolumna MedResourceID tabeli LMedResourceOrgUnit

Definicja kolumny MedResourceID tabeli LMedResourceOrgUnit

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LPersonnelTypeID tabeli LMedResourceOrgUnit

Definicja kolumny LPersonnelTypeID tabeli LMedResourceOrgUnit

Name

LPersonnelTypeID

Code

LPersonnelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli LMedResourceOrgUnit

Definicja kolumny Active tabeli LMedResourceOrgUnit

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli LMedResourceOrgUnit

Definicja kolumny StartDT tabeli LMedResourceOrgUnit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LMedResourceOrgUnit

Definicja kolumny StopDT tabeli LMedResourceOrgUnit

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LMedResourceOrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LMedResourceOrgUnit

Definicja klucza Identifier_1 tabeli LMedResourceOrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment